SELECT CHAR(72),
CHAR(101),
CHAR(108),
CHAR(108),
CHAR(111), CHAR(10);
go

SELECT UNICODE('G'),
UNICODE('o'),
UNICODE('o'),
UNICODE('d'),
UNICODE('!') ;
GO

SELECT NCHAR(71),
NCHAR(111),
NCHAR(111),
NCHAR(100),
NCHAR(33) ;
GO

Use AdventureWorks2012
go

SELECT DISTINCT
SOUNDEX(LastName),
FirstName,
LastName
FROM Person.Person
WHERE SOUNDEX(LastName) = SOUNDEX('Choi') ;

SELECT STUFF ( 'My cat''s name is X. Have you met him?', 18, 1, 'Edgar' );

SELECT STUFF ( 'My cat''s name is X. Have you met him?', 18, 1, FirstName )
FROM Person.Person
WHERE SOUNDEX(LastName) = SOUNDEX('Choi') ;